﻿//
//  Copyright (c) 2008, Rafael Bandeira
//  All rights reserved.
//
//  Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:
//
//  * Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
//
//  * Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other 
//  materials provided with the distribution.
//
//  * Neither the name of Rafael Bandeira nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior 
//  written permission.
//
//  THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT 
//  LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT 
//  OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT 
//  LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON 
//  ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE 
//  USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
//

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using Paulovich.Data;
using System.Collections.ObjectModel;

namespace Google.Web.Modulos
{
    public class Listagem<T> : System.Web.UI.Page
        where T : Persist, new()
    {
        protected Collection<T> DataSource()
        {           
            //
            // Instancia o generics
            //
            T obj = new T();

            //
            // Verifica se existe uma propriedade Nome na entidade
            //
            var property = obj.GetType().GetProperty("Nome");

            if (property != null)
            {
                //
                // Recebe o valor do nome a ser filtrado
                //
                var nome = Request.QueryString["Nome"] ?? string.Empty;

                //
                // Altera o valor do property para o valor recebido acima
                //
                property.SetValue(obj, "%" + nome + "%", null);

                //
                // Executa o select com a clausula where específica com o like
                //
                return Persist.Select<T>("Nome LIKE @Nome", obj, "Nome");

            } else {
                
                //
                // Caso não tenha encontrado a propriedade na entidade, executa um select normal
                //
                return Persist.Select<T>();
            
            }
        }

        /// <summary>
        /// Apagar entidade
        /// </summary>
        /// <param name="id">Código do registro a ser deletado</param>
        protected void Apagar(int id) {            

            //
            // Instancia o Generics
            //
            T obj = new T();
            
            //
            // Informa qual a chave-primária para localizar o registro
            // ijuiuhjuy
            // jkmj
            //
            obj.PrimaryKeys = new object[] { id };
            
            //
            // É necessário dar um get para carregar as propriedades
            // TODO: Erro de desenho, copiamos o código
            //
            if (!obj.Get())
            {
                throw new Exception("Não foi possível carregar o objeto do banco de dados.");
            }
            
            //
            // Executa o deletar no nível 0
            //
            obj.Delete(0 ,true);


        }
    }
}
